if object_id('RoomInsert') is not null
	drop proc RoomInsert
	
go

create proc RoomInsert
	@Description nvarchar(20),
	@Seats int
as
begin
	insert into Room ([Description], Seats) values (@Description, @Seats)
	select scope_identity()
end	
